{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import tushare as ts\n",
    "import sys\n",
    "reload(sys)\n",
    "sys.setdefaultencoding('utf8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>close</th>\n",
       "      <th>low</th>\n",
       "      <th>volume</th>\n",
       "      <th>price_change</th>\n",
       "      <th>p_change</th>\n",
       "      <th>ma5</th>\n",
       "      <th>ma10</th>\n",
       "      <th>ma20</th>\n",
       "      <th>v_ma5</th>\n",
       "      <th>v_ma10</th>\n",
       "      <th>v_ma20</th>\n",
       "      <th>turnover</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017-01-06</th>\n",
       "      <td>12.23</td>\n",
       "      <td>12.40</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.23</td>\n",
       "      <td>92105.65</td>\n",
       "      <td>-0.05</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>12.254</td>\n",
       "      <td>12.287</td>\n",
       "      <td>12.418</td>\n",
       "      <td>130593.68</td>\n",
       "      <td>166610.29</td>\n",
       "      <td>137516.37</td>\n",
       "      <td>0.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-05</th>\n",
       "      <td>12.36</td>\n",
       "      <td>12.50</td>\n",
       "      <td>12.30</td>\n",
       "      <td>12.25</td>\n",
       "      <td>197424.92</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>12.214</td>\n",
       "      <td>12.330</td>\n",
       "      <td>12.448</td>\n",
       "      <td>160990.53</td>\n",
       "      <td>161368.22</td>\n",
       "      <td>141333.41</td>\n",
       "      <td>1.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-04</th>\n",
       "      <td>12.25</td>\n",
       "      <td>12.42</td>\n",
       "      <td>12.39</td>\n",
       "      <td>12.21</td>\n",
       "      <td>185932.36</td>\n",
       "      <td>0.14</td>\n",
       "      <td>1.14</td>\n",
       "      <td>12.228</td>\n",
       "      <td>12.377</td>\n",
       "      <td>12.471</td>\n",
       "      <td>175493.06</td>\n",
       "      <td>153885.50</td>\n",
       "      <td>138030.96</td>\n",
       "      <td>1.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-03</th>\n",
       "      <td>12.13</td>\n",
       "      <td>12.31</td>\n",
       "      <td>12.25</td>\n",
       "      <td>12.13</td>\n",
       "      <td>97097.76</td>\n",
       "      <td>0.17</td>\n",
       "      <td>1.41</td>\n",
       "      <td>12.192</td>\n",
       "      <td>12.391</td>\n",
       "      <td>12.483</td>\n",
       "      <td>208622.91</td>\n",
       "      <td>141089.87</td>\n",
       "      <td>139437.22</td>\n",
       "      <td>0.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-30</th>\n",
       "      <td>12.07</td>\n",
       "      <td>12.19</td>\n",
       "      <td>12.08</td>\n",
       "      <td>12.04</td>\n",
       "      <td>80407.73</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.25</td>\n",
       "      <td>12.236</td>\n",
       "      <td>12.432</td>\n",
       "      <td>12.520</td>\n",
       "      <td>205606.07</td>\n",
       "      <td>138047.11</td>\n",
       "      <td>140899.68</td>\n",
       "      <td>0.75</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             open   high  close    low     volume  price_change  p_change  \\\n",
       "date                                                                        \n",
       "2017-01-06  12.23  12.40  12.25  12.23   92105.65         -0.05     -0.41   \n",
       "2017-01-05  12.36  12.50  12.30  12.25  197424.92         -0.09     -0.73   \n",
       "2017-01-04  12.25  12.42  12.39  12.21  185932.36          0.14      1.14   \n",
       "2017-01-03  12.13  12.31  12.25  12.13   97097.76          0.17      1.41   \n",
       "2016-12-30  12.07  12.19  12.08  12.04   80407.73          0.03      0.25   \n",
       "\n",
       "               ma5    ma10    ma20      v_ma5     v_ma10     v_ma20  turnover  \n",
       "date                                                                           \n",
       "2017-01-06  12.254  12.287  12.418  130593.68  166610.29  137516.37      0.86  \n",
       "2017-01-05  12.214  12.330  12.448  160990.53  161368.22  141333.41      1.85  \n",
       "2017-01-04  12.228  12.377  12.471  175493.06  153885.50  138030.96      1.75  \n",
       "2017-01-03  12.192  12.391  12.483  208622.91  141089.87  139437.22      0.91  \n",
       "2016-12-30  12.236  12.432  12.520  205606.07  138047.11  140899.68      0.75  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.get_hist_data('002185').head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "ts.get_stock_basics().head().to_csv('data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data = ts.get_stock_basics().sort_values(by='pe',ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>reserved</th>\n",
       "      <th>...</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>601288</th>\n",
       "      <td>农业银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>4.95</td>\n",
       "      <td>2940.55</td>\n",
       "      <td>3247.94</td>\n",
       "      <td>1.906410e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>14948499.00</td>\n",
       "      <td>9877300.00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.79</td>\n",
       "      <td>0.83</td>\n",
       "      <td>20100715</td>\n",
       "      <td>48712500.00</td>\n",
       "      <td>1.50</td>\n",
       "      <td>-5.19</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>39.92</td>\n",
       "      <td>482421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601166</th>\n",
       "      <td>兴业银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>福建</td>\n",
       "      <td>5.25</td>\n",
       "      <td>190.52</td>\n",
       "      <td>190.52</td>\n",
       "      <td>5.816904e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1142800.00</td>\n",
       "      <td>5086100.00</td>\n",
       "      <td>...</td>\n",
       "      <td>16.70</td>\n",
       "      <td>0.97</td>\n",
       "      <td>20070205</td>\n",
       "      <td>17284100.00</td>\n",
       "      <td>9.07</td>\n",
       "      <td>5.61</td>\n",
       "      <td>6.70</td>\n",
       "      <td>0.00</td>\n",
       "      <td>37.07</td>\n",
       "      <td>218666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601939</th>\n",
       "      <td>建设银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>5.28</td>\n",
       "      <td>95.94</td>\n",
       "      <td>2500.11</td>\n",
       "      <td>2.050068e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>16200701.00</td>\n",
       "      <td>13454301.00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.24</td>\n",
       "      <td>0.88</td>\n",
       "      <td>20070925</td>\n",
       "      <td>77305800.00</td>\n",
       "      <td>3.09</td>\n",
       "      <td>3.32</td>\n",
       "      <td>1.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41.02</td>\n",
       "      <td>440217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601398</th>\n",
       "      <td>工商银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>5.33</td>\n",
       "      <td>2696.12</td>\n",
       "      <td>3564.06</td>\n",
       "      <td>2.364647e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>20636500.00</td>\n",
       "      <td>15198099.00</td>\n",
       "      <td>...</td>\n",
       "      <td>5.21</td>\n",
       "      <td>0.85</td>\n",
       "      <td>20061027</td>\n",
       "      <td>92104800.00</td>\n",
       "      <td>2.58</td>\n",
       "      <td>-1.31</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43.03</td>\n",
       "      <td>573028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601818</th>\n",
       "      <td>光大银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>5.62</td>\n",
       "      <td>398.10</td>\n",
       "      <td>466.79</td>\n",
       "      <td>3.836367e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1380800.00</td>\n",
       "      <td>3336500.00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.67</td>\n",
       "      <td>0.84</td>\n",
       "      <td>20100818</td>\n",
       "      <td>7881000.00</td>\n",
       "      <td>1.69</td>\n",
       "      <td>1.01</td>\n",
       "      <td>2.35</td>\n",
       "      <td>0.00</td>\n",
       "      <td>34.54</td>\n",
       "      <td>275188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601988</th>\n",
       "      <td>中国银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>5.63</td>\n",
       "      <td>2107.66</td>\n",
       "      <td>2943.88</td>\n",
       "      <td>1.785750e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>18072500.00</td>\n",
       "      <td>14170800.00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.38</td>\n",
       "      <td>0.79</td>\n",
       "      <td>20060705</td>\n",
       "      <td>55911200.00</td>\n",
       "      <td>1.90</td>\n",
       "      <td>3.45</td>\n",
       "      <td>2.48</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36.53</td>\n",
       "      <td>884907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600100</th>\n",
       "      <td>同方股份</td>\n",
       "      <td>电脑设备</td>\n",
       "      <td>北京</td>\n",
       "      <td>6.04</td>\n",
       "      <td>21.98</td>\n",
       "      <td>29.64</td>\n",
       "      <td>5.865951e+06</td>\n",
       "      <td>2.892276e+06</td>\n",
       "      <td>472090.84</td>\n",
       "      <td>926180.38</td>\n",
       "      <td>...</td>\n",
       "      <td>7.65</td>\n",
       "      <td>1.81</td>\n",
       "      <td>19970627</td>\n",
       "      <td>912290.63</td>\n",
       "      <td>3.08</td>\n",
       "      <td>-4.44</td>\n",
       "      <td>799.41</td>\n",
       "      <td>17.72</td>\n",
       "      <td>29.74</td>\n",
       "      <td>233560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600015</th>\n",
       "      <td>华夏银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>6.04</td>\n",
       "      <td>106.86</td>\n",
       "      <td>106.86</td>\n",
       "      <td>2.273723e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1097500.00</td>\n",
       "      <td>2876100.00</td>\n",
       "      <td>...</td>\n",
       "      <td>12.01</td>\n",
       "      <td>0.92</td>\n",
       "      <td>20030912</td>\n",
       "      <td>5330100.00</td>\n",
       "      <td>4.99</td>\n",
       "      <td>10.25</td>\n",
       "      <td>5.07</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30.71</td>\n",
       "      <td>121711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600129</th>\n",
       "      <td>太极集团</td>\n",
       "      <td>中成药</td>\n",
       "      <td>重庆</td>\n",
       "      <td>6.07</td>\n",
       "      <td>4.27</td>\n",
       "      <td>4.27</td>\n",
       "      <td>9.766337e+05</td>\n",
       "      <td>5.172268e+05</td>\n",
       "      <td>176929.02</td>\n",
       "      <td>21943.88</td>\n",
       "      <td>...</td>\n",
       "      <td>3.73</td>\n",
       "      <td>4.72</td>\n",
       "      <td>19971118</td>\n",
       "      <td>64576.25</td>\n",
       "      <td>1.51</td>\n",
       "      <td>5.85</td>\n",
       "      <td>358.80</td>\n",
       "      <td>29.75</td>\n",
       "      <td>16.27</td>\n",
       "      <td>53839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601328</th>\n",
       "      <td>交通银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>上海</td>\n",
       "      <td>6.12</td>\n",
       "      <td>392.51</td>\n",
       "      <td>742.63</td>\n",
       "      <td>8.091810e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9585300.00</td>\n",
       "      <td>11339200.00</td>\n",
       "      <td>...</td>\n",
       "      <td>7.49</td>\n",
       "      <td>0.77</td>\n",
       "      <td>20070515</td>\n",
       "      <td>9299600.00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>0.61</td>\n",
       "      <td>1.03</td>\n",
       "      <td>0.00</td>\n",
       "      <td>35.69</td>\n",
       "      <td>408964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000001</th>\n",
       "      <td>平安银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>深圳</td>\n",
       "      <td>6.28</td>\n",
       "      <td>146.31</td>\n",
       "      <td>171.70</td>\n",
       "      <td>2.791238e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>740700.00</td>\n",
       "      <td>5646500.00</td>\n",
       "      <td>...</td>\n",
       "      <td>10.38</td>\n",
       "      <td>0.88</td>\n",
       "      <td>19910403</td>\n",
       "      <td>6946300.00</td>\n",
       "      <td>4.05</td>\n",
       "      <td>15.20</td>\n",
       "      <td>5.52</td>\n",
       "      <td>0.00</td>\n",
       "      <td>22.84</td>\n",
       "      <td>340324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600016</th>\n",
       "      <td>民生银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>6.30</td>\n",
       "      <td>295.52</td>\n",
       "      <td>364.85</td>\n",
       "      <td>5.636577e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3827100.00</td>\n",
       "      <td>6474400.00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.95</td>\n",
       "      <td>1.01</td>\n",
       "      <td>20001219</td>\n",
       "      <td>13243800.00</td>\n",
       "      <td>3.63</td>\n",
       "      <td>0.18</td>\n",
       "      <td>2.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33.65</td>\n",
       "      <td>316935</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600000</th>\n",
       "      <td>浦发银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>上海</td>\n",
       "      <td>6.45</td>\n",
       "      <td>205.19</td>\n",
       "      <td>216.18</td>\n",
       "      <td>5.564282e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2097700.00</td>\n",
       "      <td>7467800.00</td>\n",
       "      <td>...</td>\n",
       "      <td>15.26</td>\n",
       "      <td>1.06</td>\n",
       "      <td>19991110</td>\n",
       "      <td>8579200.00</td>\n",
       "      <td>3.97</td>\n",
       "      <td>11.32</td>\n",
       "      <td>9.47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33.64</td>\n",
       "      <td>162071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600036</th>\n",
       "      <td>招商银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>深圳</td>\n",
       "      <td>6.52</td>\n",
       "      <td>206.29</td>\n",
       "      <td>252.20</td>\n",
       "      <td>5.563990e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3591400.00</td>\n",
       "      <td>6752300.00</td>\n",
       "      <td>...</td>\n",
       "      <td>15.72</td>\n",
       "      <td>1.14</td>\n",
       "      <td>20020409</td>\n",
       "      <td>19801900.00</td>\n",
       "      <td>7.85</td>\n",
       "      <td>2.60</td>\n",
       "      <td>7.51</td>\n",
       "      <td>0.00</td>\n",
       "      <td>32.53</td>\n",
       "      <td>215532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000625</th>\n",
       "      <td>长安汽车</td>\n",
       "      <td>汽车整车</td>\n",
       "      <td>重庆</td>\n",
       "      <td>7.07</td>\n",
       "      <td>37.61</td>\n",
       "      <td>48.03</td>\n",
       "      <td>1.006183e+07</td>\n",
       "      <td>5.804083e+06</td>\n",
       "      <td>1492460.25</td>\n",
       "      <td>322748.94</td>\n",
       "      <td>...</td>\n",
       "      <td>8.37</td>\n",
       "      <td>1.81</td>\n",
       "      <td>19970610</td>\n",
       "      <td>2865065.25</td>\n",
       "      <td>5.97</td>\n",
       "      <td>11.43</td>\n",
       "      <td>14.81</td>\n",
       "      <td>17.18</td>\n",
       "      <td>14.44</td>\n",
       "      <td>143113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601998</th>\n",
       "      <td>中信银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>7.21</td>\n",
       "      <td>319.05</td>\n",
       "      <td>489.35</td>\n",
       "      <td>5.541535e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1544000.00</td>\n",
       "      <td>5863600.00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.99</td>\n",
       "      <td>0.97</td>\n",
       "      <td>20070427</td>\n",
       "      <td>14283699.00</td>\n",
       "      <td>2.92</td>\n",
       "      <td>7.34</td>\n",
       "      <td>4.91</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.95</td>\n",
       "      <td>205677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000600</th>\n",
       "      <td>建投能源</td>\n",
       "      <td>火力发电</td>\n",
       "      <td>河北</td>\n",
       "      <td>7.37</td>\n",
       "      <td>10.90</td>\n",
       "      <td>17.92</td>\n",
       "      <td>2.766110e+06</td>\n",
       "      <td>3.989108e+05</td>\n",
       "      <td>1423318.25</td>\n",
       "      <td>440487.59</td>\n",
       "      <td>...</td>\n",
       "      <td>6.37</td>\n",
       "      <td>1.41</td>\n",
       "      <td>19960606</td>\n",
       "      <td>478985.81</td>\n",
       "      <td>2.67</td>\n",
       "      <td>-5.53</td>\n",
       "      <td>-6.25</td>\n",
       "      <td>41.48</td>\n",
       "      <td>24.21</td>\n",
       "      <td>53737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601169</th>\n",
       "      <td>北京银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>北京</td>\n",
       "      <td>7.50</td>\n",
       "      <td>152.07</td>\n",
       "      <td>152.07</td>\n",
       "      <td>2.042843e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>791700.00</td>\n",
       "      <td>2623600.00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.12</td>\n",
       "      <td>1.21</td>\n",
       "      <td>20070919</td>\n",
       "      <td>4749500.00</td>\n",
       "      <td>3.12</td>\n",
       "      <td>10.07</td>\n",
       "      <td>5.79</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41.20</td>\n",
       "      <td>157219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002142</th>\n",
       "      <td>宁波银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>浙江</td>\n",
       "      <td>7.95</td>\n",
       "      <td>34.52</td>\n",
       "      <td>39.00</td>\n",
       "      <td>8.376893e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>334290.19</td>\n",
       "      <td>994823.63</td>\n",
       "      <td>...</td>\n",
       "      <td>11.65</td>\n",
       "      <td>1.48</td>\n",
       "      <td>20070719</td>\n",
       "      <td>1984291.75</td>\n",
       "      <td>5.09</td>\n",
       "      <td>27.01</td>\n",
       "      <td>19.22</td>\n",
       "      <td>0.00</td>\n",
       "      <td>35.36</td>\n",
       "      <td>86763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601009</th>\n",
       "      <td>南京银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>江苏</td>\n",
       "      <td>8.02</td>\n",
       "      <td>57.64</td>\n",
       "      <td>60.59</td>\n",
       "      <td>1.023218e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>511091.00</td>\n",
       "      <td>1518646.25</td>\n",
       "      <td>...</td>\n",
       "      <td>10.17</td>\n",
       "      <td>1.10</td>\n",
       "      <td>20070719</td>\n",
       "      <td>1694453.25</td>\n",
       "      <td>2.80</td>\n",
       "      <td>26.84</td>\n",
       "      <td>22.67</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30.16</td>\n",
       "      <td>85675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600177</th>\n",
       "      <td>雅戈尔</td>\n",
       "      <td>服饰</td>\n",
       "      <td>浙江</td>\n",
       "      <td>8.05</td>\n",
       "      <td>22.27</td>\n",
       "      <td>25.58</td>\n",
       "      <td>6.449872e+06</td>\n",
       "      <td>2.741906e+06</td>\n",
       "      <td>437789.19</td>\n",
       "      <td>488559.69</td>\n",
       "      <td>...</td>\n",
       "      <td>8.86</td>\n",
       "      <td>1.57</td>\n",
       "      <td>19981119</td>\n",
       "      <td>1518807.13</td>\n",
       "      <td>5.94</td>\n",
       "      <td>-14.95</td>\n",
       "      <td>1.64</td>\n",
       "      <td>42.38</td>\n",
       "      <td>31.43</td>\n",
       "      <td>140872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601668</th>\n",
       "      <td>中国建筑</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>北京</td>\n",
       "      <td>8.07</td>\n",
       "      <td>299.47</td>\n",
       "      <td>300.00</td>\n",
       "      <td>1.343098e+08</td>\n",
       "      <td>1.069322e+08</td>\n",
       "      <td>2756152.75</td>\n",
       "      <td>1529999.38</td>\n",
       "      <td>...</td>\n",
       "      <td>6.21</td>\n",
       "      <td>1.43</td>\n",
       "      <td>20090729</td>\n",
       "      <td>11804222.00</td>\n",
       "      <td>3.93</td>\n",
       "      <td>9.63</td>\n",
       "      <td>30.05</td>\n",
       "      <td>9.46</td>\n",
       "      <td>3.70</td>\n",
       "      <td>775140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600029</th>\n",
       "      <td>南方航空</td>\n",
       "      <td>空运</td>\n",
       "      <td>广东</td>\n",
       "      <td>8.17</td>\n",
       "      <td>70.23</td>\n",
       "      <td>98.18</td>\n",
       "      <td>1.925870e+07</td>\n",
       "      <td>1.390200e+06</td>\n",
       "      <td>14417901.00</td>\n",
       "      <td>1395100.00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.52</td>\n",
       "      <td>1.58</td>\n",
       "      <td>20030725</td>\n",
       "      <td>1903500.00</td>\n",
       "      <td>1.94</td>\n",
       "      <td>1.52</td>\n",
       "      <td>37.45</td>\n",
       "      <td>19.54</td>\n",
       "      <td>7.43</td>\n",
       "      <td>295297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600741</th>\n",
       "      <td>华域汽车</td>\n",
       "      <td>汽车配件</td>\n",
       "      <td>上海</td>\n",
       "      <td>8.48</td>\n",
       "      <td>25.83</td>\n",
       "      <td>31.53</td>\n",
       "      <td>1.029029e+07</td>\n",
       "      <td>6.456056e+06</td>\n",
       "      <td>1394430.38</td>\n",
       "      <td>1251345.88</td>\n",
       "      <td>...</td>\n",
       "      <td>11.53</td>\n",
       "      <td>1.39</td>\n",
       "      <td>19960826</td>\n",
       "      <td>1713783.75</td>\n",
       "      <td>5.44</td>\n",
       "      <td>29.11</td>\n",
       "      <td>12.11</td>\n",
       "      <td>13.75</td>\n",
       "      <td>4.81</td>\n",
       "      <td>63088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600104</th>\n",
       "      <td>上汽集团</td>\n",
       "      <td>汽车整车</td>\n",
       "      <td>上海</td>\n",
       "      <td>8.56</td>\n",
       "      <td>110.26</td>\n",
       "      <td>110.26</td>\n",
       "      <td>5.449458e+07</td>\n",
       "      <td>2.930907e+07</td>\n",
       "      <td>4209782.50</td>\n",
       "      <td>4098541.50</td>\n",
       "      <td>...</td>\n",
       "      <td>16.70</td>\n",
       "      <td>1.43</td>\n",
       "      <td>19971125</td>\n",
       "      <td>9434767.00</td>\n",
       "      <td>8.56</td>\n",
       "      <td>11.50</td>\n",
       "      <td>8.60</td>\n",
       "      <td>12.42</td>\n",
       "      <td>4.41</td>\n",
       "      <td>103501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600011</th>\n",
       "      <td>华能国际</td>\n",
       "      <td>火力发电</td>\n",
       "      <td>北京</td>\n",
       "      <td>8.60</td>\n",
       "      <td>105.00</td>\n",
       "      <td>152.00</td>\n",
       "      <td>2.997238e+07</td>\n",
       "      <td>3.045625e+06</td>\n",
       "      <td>19128846.00</td>\n",
       "      <td>1825077.75</td>\n",
       "      <td>...</td>\n",
       "      <td>5.45</td>\n",
       "      <td>1.30</td>\n",
       "      <td>20011206</td>\n",
       "      <td>3980688.75</td>\n",
       "      <td>2.62</td>\n",
       "      <td>-14.43</td>\n",
       "      <td>-29.06</td>\n",
       "      <td>26.89</td>\n",
       "      <td>11.28</td>\n",
       "      <td>97887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601318</th>\n",
       "      <td>中国平安</td>\n",
       "      <td>保险</td>\n",
       "      <td>深圳</td>\n",
       "      <td>8.60</td>\n",
       "      <td>108.33</td>\n",
       "      <td>182.80</td>\n",
       "      <td>5.296564e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3628800.00</td>\n",
       "      <td>12264600.00</td>\n",
       "      <td>...</td>\n",
       "      <td>20.75</td>\n",
       "      <td>1.71</td>\n",
       "      <td>20070301</td>\n",
       "      <td>18007000.00</td>\n",
       "      <td>9.85</td>\n",
       "      <td>15.41</td>\n",
       "      <td>17.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.35</td>\n",
       "      <td>274601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600730</th>\n",
       "      <td>中国高科</td>\n",
       "      <td>综合类</td>\n",
       "      <td>北京</td>\n",
       "      <td>8.66</td>\n",
       "      <td>5.87</td>\n",
       "      <td>5.87</td>\n",
       "      <td>4.446449e+05</td>\n",
       "      <td>3.642337e+05</td>\n",
       "      <td>355.26</td>\n",
       "      <td>5055.50</td>\n",
       "      <td>...</td>\n",
       "      <td>3.47</td>\n",
       "      <td>3.61</td>\n",
       "      <td>19960726</td>\n",
       "      <td>97027.65</td>\n",
       "      <td>1.65</td>\n",
       "      <td>94.40</td>\n",
       "      <td>878.09</td>\n",
       "      <td>3.08</td>\n",
       "      <td>54.62</td>\n",
       "      <td>71056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600718</th>\n",
       "      <td>东软集团</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>辽宁</td>\n",
       "      <td>8.85</td>\n",
       "      <td>12.32</td>\n",
       "      <td>12.43</td>\n",
       "      <td>1.134156e+06</td>\n",
       "      <td>5.830918e+05</td>\n",
       "      <td>148886.63</td>\n",
       "      <td>69191.85</td>\n",
       "      <td>...</td>\n",
       "      <td>6.34</td>\n",
       "      <td>3.06</td>\n",
       "      <td>19960618</td>\n",
       "      <td>523895.31</td>\n",
       "      <td>4.21</td>\n",
       "      <td>1.77</td>\n",
       "      <td>1161.01</td>\n",
       "      <td>33.60</td>\n",
       "      <td>41.48</td>\n",
       "      <td>86139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601229</th>\n",
       "      <td>上海银行</td>\n",
       "      <td>银行</td>\n",
       "      <td>上海</td>\n",
       "      <td>9.56</td>\n",
       "      <td>6.00</td>\n",
       "      <td>60.04</td>\n",
       "      <td>1.650924e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>390415.59</td>\n",
       "      <td>2039269.75</td>\n",
       "      <td>...</td>\n",
       "      <td>19.13</td>\n",
       "      <td>1.21</td>\n",
       "      <td>20161116</td>\n",
       "      <td>3215868.50</td>\n",
       "      <td>5.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41.30</td>\n",
       "      <td>551958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000567</th>\n",
       "      <td>海德股份</td>\n",
       "      <td>区域地产</td>\n",
       "      <td>海南</td>\n",
       "      <td>2692.87</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1.51</td>\n",
       "      <td>2.634341e+04</td>\n",
       "      <td>1.868432e+04</td>\n",
       "      <td>574.40</td>\n",
       "      <td>11672.82</td>\n",
       "      <td>...</td>\n",
       "      <td>1.46</td>\n",
       "      <td>26.47</td>\n",
       "      <td>19940525</td>\n",
       "      <td>-4852.41</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>64.80</td>\n",
       "      <td>-88.81</td>\n",
       "      <td>50.22</td>\n",
       "      <td>7.84</td>\n",
       "      <td>13380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000017</th>\n",
       "      <td>深中华A</td>\n",
       "      <td>文教休闲</td>\n",
       "      <td>深圳</td>\n",
       "      <td>2762.70</td>\n",
       "      <td>3.03</td>\n",
       "      <td>5.51</td>\n",
       "      <td>6.341910e+03</td>\n",
       "      <td>5.631660e+03</td>\n",
       "      <td>381.31</td>\n",
       "      <td>62783.43</td>\n",
       "      <td>...</td>\n",
       "      <td>0.03</td>\n",
       "      <td>553.51</td>\n",
       "      <td>19920331</td>\n",
       "      <td>-119800.97</td>\n",
       "      <td>-2.17</td>\n",
       "      <td>-13.91</td>\n",
       "      <td>286.64</td>\n",
       "      <td>9.63</td>\n",
       "      <td>1.73</td>\n",
       "      <td>53355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300122</th>\n",
       "      <td>智飞生物</td>\n",
       "      <td>生物制药</td>\n",
       "      <td>重庆</td>\n",
       "      <td>2908.95</td>\n",
       "      <td>8.63</td>\n",
       "      <td>16.00</td>\n",
       "      <td>2.630953e+05</td>\n",
       "      <td>1.134749e+05</td>\n",
       "      <td>60383.13</td>\n",
       "      <td>20796.47</td>\n",
       "      <td>...</td>\n",
       "      <td>1.56</td>\n",
       "      <td>10.51</td>\n",
       "      <td>20100928</td>\n",
       "      <td>60421.76</td>\n",
       "      <td>0.38</td>\n",
       "      <td>-50.79</td>\n",
       "      <td>-95.79</td>\n",
       "      <td>92.73</td>\n",
       "      <td>2.47</td>\n",
       "      <td>12761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300469</th>\n",
       "      <td>信息发展</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>上海</td>\n",
       "      <td>3047.43</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.68</td>\n",
       "      <td>8.266959e+04</td>\n",
       "      <td>7.082196e+04</td>\n",
       "      <td>1580.30</td>\n",
       "      <td>21445.93</td>\n",
       "      <td>...</td>\n",
       "      <td>6.12</td>\n",
       "      <td>12.75</td>\n",
       "      <td>20150611</td>\n",
       "      <td>12021.07</td>\n",
       "      <td>1.76</td>\n",
       "      <td>34.87</td>\n",
       "      <td>156.65</td>\n",
       "      <td>41.20</td>\n",
       "      <td>0.44</td>\n",
       "      <td>15310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603227</th>\n",
       "      <td>雪峰科技</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>新疆</td>\n",
       "      <td>3093.47</td>\n",
       "      <td>4.22</td>\n",
       "      <td>6.59</td>\n",
       "      <td>2.646787e+05</td>\n",
       "      <td>1.367015e+05</td>\n",
       "      <td>88838.60</td>\n",
       "      <td>32702.28</td>\n",
       "      <td>...</td>\n",
       "      <td>1.75</td>\n",
       "      <td>4.74</td>\n",
       "      <td>20150515</td>\n",
       "      <td>11085.57</td>\n",
       "      <td>0.17</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-98.66</td>\n",
       "      <td>24.90</td>\n",
       "      <td>0.22</td>\n",
       "      <td>46228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000678</th>\n",
       "      <td>襄阳轴承</td>\n",
       "      <td>机械基件</td>\n",
       "      <td>湖北</td>\n",
       "      <td>3165.57</td>\n",
       "      <td>4.29</td>\n",
       "      <td>4.60</td>\n",
       "      <td>2.598847e+05</td>\n",
       "      <td>1.109135e+05</td>\n",
       "      <td>88834.68</td>\n",
       "      <td>71874.57</td>\n",
       "      <td>...</td>\n",
       "      <td>2.55</td>\n",
       "      <td>6.06</td>\n",
       "      <td>19970106</td>\n",
       "      <td>-7968.81</td>\n",
       "      <td>-0.17</td>\n",
       "      <td>20.28</td>\n",
       "      <td>105.59</td>\n",
       "      <td>9.78</td>\n",
       "      <td>0.15</td>\n",
       "      <td>39676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600365</th>\n",
       "      <td>通葡股份</td>\n",
       "      <td>红黄药酒</td>\n",
       "      <td>吉林</td>\n",
       "      <td>3268.34</td>\n",
       "      <td>4.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>9.044611e+04</td>\n",
       "      <td>6.185193e+04</td>\n",
       "      <td>13715.70</td>\n",
       "      <td>54790.86</td>\n",
       "      <td>...</td>\n",
       "      <td>1.71</td>\n",
       "      <td>6.55</td>\n",
       "      <td>20010115</td>\n",
       "      <td>-26907.95</td>\n",
       "      <td>-0.67</td>\n",
       "      <td>32.55</td>\n",
       "      <td>-44.72</td>\n",
       "      <td>20.25</td>\n",
       "      <td>0.27</td>\n",
       "      <td>34615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000885</th>\n",
       "      <td>同力水泥</td>\n",
       "      <td>水泥</td>\n",
       "      <td>河南</td>\n",
       "      <td>3402.66</td>\n",
       "      <td>4.27</td>\n",
       "      <td>4.75</td>\n",
       "      <td>6.076552e+05</td>\n",
       "      <td>1.004939e+05</td>\n",
       "      <td>319444.41</td>\n",
       "      <td>119025.63</td>\n",
       "      <td>...</td>\n",
       "      <td>4.61</td>\n",
       "      <td>4.45</td>\n",
       "      <td>19990319</td>\n",
       "      <td>40866.26</td>\n",
       "      <td>0.86</td>\n",
       "      <td>-10.47</td>\n",
       "      <td>-97.62</td>\n",
       "      <td>20.99</td>\n",
       "      <td>0.10</td>\n",
       "      <td>23748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600234</th>\n",
       "      <td>*ST山水</td>\n",
       "      <td>文教休闲</td>\n",
       "      <td>山西</td>\n",
       "      <td>3682.71</td>\n",
       "      <td>2.02</td>\n",
       "      <td>2.02</td>\n",
       "      <td>4.892103e+04</td>\n",
       "      <td>1.368140e+03</td>\n",
       "      <td>159.75</td>\n",
       "      <td>29344.50</td>\n",
       "      <td>...</td>\n",
       "      <td>0.24</td>\n",
       "      <td>78.25</td>\n",
       "      <td>20000615</td>\n",
       "      <td>-46093.07</td>\n",
       "      <td>-2.28</td>\n",
       "      <td>34.35</td>\n",
       "      <td>105.33</td>\n",
       "      <td>-66.01</td>\n",
       "      <td>6.86</td>\n",
       "      <td>20994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600207</th>\n",
       "      <td>安彩高科</td>\n",
       "      <td>元器件</td>\n",
       "      <td>河南</td>\n",
       "      <td>3731.21</td>\n",
       "      <td>6.90</td>\n",
       "      <td>8.63</td>\n",
       "      <td>2.440060e+05</td>\n",
       "      <td>1.181447e+05</td>\n",
       "      <td>72502.10</td>\n",
       "      <td>287230.00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.18</td>\n",
       "      <td>4.22</td>\n",
       "      <td>19990714</td>\n",
       "      <td>-224799.95</td>\n",
       "      <td>-2.60</td>\n",
       "      <td>7.10</td>\n",
       "      <td>-97.26</td>\n",
       "      <td>12.92</td>\n",
       "      <td>0.12</td>\n",
       "      <td>49192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000677</th>\n",
       "      <td>恒天海龙</td>\n",
       "      <td>化纤</td>\n",
       "      <td>山东</td>\n",
       "      <td>3792.81</td>\n",
       "      <td>8.64</td>\n",
       "      <td>8.64</td>\n",
       "      <td>8.437747e+04</td>\n",
       "      <td>3.221469e+04</td>\n",
       "      <td>42395.84</td>\n",
       "      <td>69768.81</td>\n",
       "      <td>...</td>\n",
       "      <td>0.31</td>\n",
       "      <td>22.96</td>\n",
       "      <td>19961226</td>\n",
       "      <td>-150702.95</td>\n",
       "      <td>-1.74</td>\n",
       "      <td>-77.44</td>\n",
       "      <td>100.49</td>\n",
       "      <td>15.32</td>\n",
       "      <td>0.33</td>\n",
       "      <td>57272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000806</th>\n",
       "      <td>银河生物</td>\n",
       "      <td>生物制药</td>\n",
       "      <td>广西</td>\n",
       "      <td>3829.75</td>\n",
       "      <td>6.98</td>\n",
       "      <td>11.00</td>\n",
       "      <td>2.832541e+05</td>\n",
       "      <td>1.715002e+05</td>\n",
       "      <td>37434.06</td>\n",
       "      <td>105668.88</td>\n",
       "      <td>...</td>\n",
       "      <td>1.84</td>\n",
       "      <td>8.88</td>\n",
       "      <td>19980416</td>\n",
       "      <td>-22164.46</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>38.52</td>\n",
       "      <td>-96.60</td>\n",
       "      <td>25.25</td>\n",
       "      <td>0.42</td>\n",
       "      <td>81900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002755</th>\n",
       "      <td>东方新星</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>北京</td>\n",
       "      <td>3830.17</td>\n",
       "      <td>0.35</td>\n",
       "      <td>1.01</td>\n",
       "      <td>6.840993e+04</td>\n",
       "      <td>6.353088e+04</td>\n",
       "      <td>3499.25</td>\n",
       "      <td>14137.30</td>\n",
       "      <td>...</td>\n",
       "      <td>5.00</td>\n",
       "      <td>7.94</td>\n",
       "      <td>20150515</td>\n",
       "      <td>23398.80</td>\n",
       "      <td>2.31</td>\n",
       "      <td>-48.84</td>\n",
       "      <td>-95.92</td>\n",
       "      <td>13.42</td>\n",
       "      <td>0.74</td>\n",
       "      <td>21214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600870</th>\n",
       "      <td>厦华电子</td>\n",
       "      <td>家用电器</td>\n",
       "      <td>福建</td>\n",
       "      <td>4031.30</td>\n",
       "      <td>5.23</td>\n",
       "      <td>5.23</td>\n",
       "      <td>3.363180e+03</td>\n",
       "      <td>3.325810e+03</td>\n",
       "      <td>5.36</td>\n",
       "      <td>228420.30</td>\n",
       "      <td>...</td>\n",
       "      <td>0.04</td>\n",
       "      <td>236.10</td>\n",
       "      <td>19950228</td>\n",
       "      <td>-285958.34</td>\n",
       "      <td>-5.47</td>\n",
       "      <td>1055.98</td>\n",
       "      <td>-86.42</td>\n",
       "      <td>2.73</td>\n",
       "      <td>0.26</td>\n",
       "      <td>28634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600435</th>\n",
       "      <td>北方导航</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>北京</td>\n",
       "      <td>4103.53</td>\n",
       "      <td>14.89</td>\n",
       "      <td>14.89</td>\n",
       "      <td>4.290577e+05</td>\n",
       "      <td>2.603250e+05</td>\n",
       "      <td>98119.21</td>\n",
       "      <td>7020.97</td>\n",
       "      <td>...</td>\n",
       "      <td>1.36</td>\n",
       "      <td>10.30</td>\n",
       "      <td>20030704</td>\n",
       "      <td>38081.90</td>\n",
       "      <td>0.26</td>\n",
       "      <td>3.71</td>\n",
       "      <td>12.68</td>\n",
       "      <td>29.44</td>\n",
       "      <td>0.41</td>\n",
       "      <td>139413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002192</th>\n",
       "      <td>融捷股份</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>广东</td>\n",
       "      <td>4225.71</td>\n",
       "      <td>1.90</td>\n",
       "      <td>2.60</td>\n",
       "      <td>9.600925e+04</td>\n",
       "      <td>3.076586e+04</td>\n",
       "      <td>12430.26</td>\n",
       "      <td>51183.68</td>\n",
       "      <td>...</td>\n",
       "      <td>2.82</td>\n",
       "      <td>7.94</td>\n",
       "      <td>20071205</td>\n",
       "      <td>-5361.30</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>32.35</td>\n",
       "      <td>109.61</td>\n",
       "      <td>34.27</td>\n",
       "      <td>0.66</td>\n",
       "      <td>38248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600836</th>\n",
       "      <td>界龙实业</td>\n",
       "      <td>广告包装</td>\n",
       "      <td>上海</td>\n",
       "      <td>4315.60</td>\n",
       "      <td>6.53</td>\n",
       "      <td>6.63</td>\n",
       "      <td>3.271772e+05</td>\n",
       "      <td>2.108945e+05</td>\n",
       "      <td>58898.56</td>\n",
       "      <td>10020.80</td>\n",
       "      <td>...</td>\n",
       "      <td>1.32</td>\n",
       "      <td>6.81</td>\n",
       "      <td>19940224</td>\n",
       "      <td>10631.44</td>\n",
       "      <td>0.16</td>\n",
       "      <td>31.98</td>\n",
       "      <td>-74.15</td>\n",
       "      <td>15.36</td>\n",
       "      <td>0.09</td>\n",
       "      <td>77781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300128</th>\n",
       "      <td>锦富新材</td>\n",
       "      <td>元器件</td>\n",
       "      <td>江苏</td>\n",
       "      <td>4461.88</td>\n",
       "      <td>3.13</td>\n",
       "      <td>4.79</td>\n",
       "      <td>3.613169e+05</td>\n",
       "      <td>1.810279e+05</td>\n",
       "      <td>54136.43</td>\n",
       "      <td>130508.92</td>\n",
       "      <td>...</td>\n",
       "      <td>4.63</td>\n",
       "      <td>3.74</td>\n",
       "      <td>20101013</td>\n",
       "      <td>40601.00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>-17.70</td>\n",
       "      <td>-72.44</td>\n",
       "      <td>11.43</td>\n",
       "      <td>0.07</td>\n",
       "      <td>19633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600573</th>\n",
       "      <td>惠泉啤酒</td>\n",
       "      <td>啤酒</td>\n",
       "      <td>福建</td>\n",
       "      <td>4539.74</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1.200594e+05</td>\n",
       "      <td>6.282566e+04</td>\n",
       "      <td>48567.73</td>\n",
       "      <td>50606.55</td>\n",
       "      <td>...</td>\n",
       "      <td>4.37</td>\n",
       "      <td>3.64</td>\n",
       "      <td>20030226</td>\n",
       "      <td>20337.03</td>\n",
       "      <td>0.81</td>\n",
       "      <td>-20.58</td>\n",
       "      <td>-98.26</td>\n",
       "      <td>33.46</td>\n",
       "      <td>0.13</td>\n",
       "      <td>12777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600685</th>\n",
       "      <td>中船防务</td>\n",
       "      <td>船舶</td>\n",
       "      <td>广东</td>\n",
       "      <td>5027.52</td>\n",
       "      <td>5.49</td>\n",
       "      <td>14.14</td>\n",
       "      <td>5.091487e+06</td>\n",
       "      <td>3.641800e+06</td>\n",
       "      <td>1028224.63</td>\n",
       "      <td>686758.50</td>\n",
       "      <td>...</td>\n",
       "      <td>7.27</td>\n",
       "      <td>4.31</td>\n",
       "      <td>19931028</td>\n",
       "      <td>111755.51</td>\n",
       "      <td>0.79</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>100.70</td>\n",
       "      <td>6.14</td>\n",
       "      <td>0.04</td>\n",
       "      <td>50359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002468</th>\n",
       "      <td>申通快递</td>\n",
       "      <td>仓储物流</td>\n",
       "      <td>浙江</td>\n",
       "      <td>6677.47</td>\n",
       "      <td>3.32</td>\n",
       "      <td>15.31</td>\n",
       "      <td>1.538426e+05</td>\n",
       "      <td>9.928536e+04</td>\n",
       "      <td>41224.78</td>\n",
       "      <td>26216.80</td>\n",
       "      <td>...</td>\n",
       "      <td>2.20</td>\n",
       "      <td>13.78</td>\n",
       "      <td>20100908</td>\n",
       "      <td>10487.73</td>\n",
       "      <td>0.07</td>\n",
       "      <td>2.77</td>\n",
       "      <td>5.38</td>\n",
       "      <td>14.47</td>\n",
       "      <td>0.48</td>\n",
       "      <td>24617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300093</th>\n",
       "      <td>金刚玻璃</td>\n",
       "      <td>玻璃</td>\n",
       "      <td>广东</td>\n",
       "      <td>7340.19</td>\n",
       "      <td>2.15</td>\n",
       "      <td>2.16</td>\n",
       "      <td>1.277433e+05</td>\n",
       "      <td>7.190043e+04</td>\n",
       "      <td>46292.26</td>\n",
       "      <td>38683.30</td>\n",
       "      <td>...</td>\n",
       "      <td>4.04</td>\n",
       "      <td>5.93</td>\n",
       "      <td>20100708</td>\n",
       "      <td>22002.77</td>\n",
       "      <td>1.02</td>\n",
       "      <td>-8.00</td>\n",
       "      <td>-93.83</td>\n",
       "      <td>35.96</td>\n",
       "      <td>0.22</td>\n",
       "      <td>17041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002232</th>\n",
       "      <td>启明信息</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>吉林</td>\n",
       "      <td>8756.48</td>\n",
       "      <td>4.02</td>\n",
       "      <td>4.09</td>\n",
       "      <td>1.586020e+05</td>\n",
       "      <td>1.071229e+05</td>\n",
       "      <td>34809.59</td>\n",
       "      <td>26188.17</td>\n",
       "      <td>...</td>\n",
       "      <td>2.46</td>\n",
       "      <td>5.42</td>\n",
       "      <td>20080509</td>\n",
       "      <td>28205.65</td>\n",
       "      <td>0.69</td>\n",
       "      <td>-20.80</td>\n",
       "      <td>105.16</td>\n",
       "      <td>19.72</td>\n",
       "      <td>0.08</td>\n",
       "      <td>52591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600316</th>\n",
       "      <td>洪都航空</td>\n",
       "      <td>航空</td>\n",
       "      <td>江西</td>\n",
       "      <td>8969.72</td>\n",
       "      <td>7.17</td>\n",
       "      <td>7.17</td>\n",
       "      <td>1.116128e+06</td>\n",
       "      <td>6.728828e+05</td>\n",
       "      <td>149892.22</td>\n",
       "      <td>314009.31</td>\n",
       "      <td>...</td>\n",
       "      <td>7.18</td>\n",
       "      <td>2.88</td>\n",
       "      <td>20001215</td>\n",
       "      <td>66772.96</td>\n",
       "      <td>0.93</td>\n",
       "      <td>26.50</td>\n",
       "      <td>-88.75</td>\n",
       "      <td>6.49</td>\n",
       "      <td>0.06</td>\n",
       "      <td>57176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600728</th>\n",
       "      <td>佳都科技</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>广东</td>\n",
       "      <td>9268.25</td>\n",
       "      <td>13.09</td>\n",
       "      <td>15.54</td>\n",
       "      <td>3.932289e+05</td>\n",
       "      <td>3.268362e+05</td>\n",
       "      <td>7726.83</td>\n",
       "      <td>111346.32</td>\n",
       "      <td>...</td>\n",
       "      <td>1.66</td>\n",
       "      <td>5.14</td>\n",
       "      <td>19960716</td>\n",
       "      <td>-17294.75</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>7.42</td>\n",
       "      <td>107.65</td>\n",
       "      <td>14.49</td>\n",
       "      <td>0.07</td>\n",
       "      <td>72583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000881</th>\n",
       "      <td>大连国际</td>\n",
       "      <td>综合类</td>\n",
       "      <td>辽宁</td>\n",
       "      <td>10892.01</td>\n",
       "      <td>3.08</td>\n",
       "      <td>3.09</td>\n",
       "      <td>4.570207e+05</td>\n",
       "      <td>2.754908e+05</td>\n",
       "      <td>177149.02</td>\n",
       "      <td>25370.17</td>\n",
       "      <td>...</td>\n",
       "      <td>2.69</td>\n",
       "      <td>10.40</td>\n",
       "      <td>19980902</td>\n",
       "      <td>17582.60</td>\n",
       "      <td>0.57</td>\n",
       "      <td>-3.67</td>\n",
       "      <td>100.07</td>\n",
       "      <td>10.86</td>\n",
       "      <td>0.04</td>\n",
       "      <td>23153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603003</th>\n",
       "      <td>龙宇燃油</td>\n",
       "      <td>石油贸易</td>\n",
       "      <td>上海</td>\n",
       "      <td>11344.45</td>\n",
       "      <td>2.02</td>\n",
       "      <td>4.41</td>\n",
       "      <td>5.942213e+05</td>\n",
       "      <td>5.463700e+05</td>\n",
       "      <td>13997.30</td>\n",
       "      <td>354252.78</td>\n",
       "      <td>...</td>\n",
       "      <td>9.23</td>\n",
       "      <td>2.33</td>\n",
       "      <td>20120817</td>\n",
       "      <td>5864.00</td>\n",
       "      <td>0.13</td>\n",
       "      <td>39.36</td>\n",
       "      <td>100.95</td>\n",
       "      <td>0.94</td>\n",
       "      <td>0.01</td>\n",
       "      <td>10977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000691</th>\n",
       "      <td>ST亚太</td>\n",
       "      <td>区域地产</td>\n",
       "      <td>甘肃</td>\n",
       "      <td>17617.77</td>\n",
       "      <td>2.90</td>\n",
       "      <td>3.23</td>\n",
       "      <td>2.812445e+04</td>\n",
       "      <td>2.675598e+04</td>\n",
       "      <td>87.48</td>\n",
       "      <td>14785.37</td>\n",
       "      <td>...</td>\n",
       "      <td>0.26</td>\n",
       "      <td>41.37</td>\n",
       "      <td>19970228</td>\n",
       "      <td>-40366.71</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-52.96</td>\n",
       "      <td>108.00</td>\n",
       "      <td>30.67</td>\n",
       "      <td>0.63</td>\n",
       "      <td>17725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000767</th>\n",
       "      <td>漳泽电力</td>\n",
       "      <td>火力发电</td>\n",
       "      <td>山西</td>\n",
       "      <td>20144.57</td>\n",
       "      <td>22.54</td>\n",
       "      <td>22.54</td>\n",
       "      <td>4.053260e+06</td>\n",
       "      <td>8.162328e+05</td>\n",
       "      <td>2205825.50</td>\n",
       "      <td>228593.95</td>\n",
       "      <td>...</td>\n",
       "      <td>2.57</td>\n",
       "      <td>1.53</td>\n",
       "      <td>19970609</td>\n",
       "      <td>107255.30</td>\n",
       "      <td>0.48</td>\n",
       "      <td>-33.18</td>\n",
       "      <td>-99.90</td>\n",
       "      <td>15.45</td>\n",
       "      <td>0.01</td>\n",
       "      <td>167387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600561</th>\n",
       "      <td>江西长运</td>\n",
       "      <td>公路</td>\n",
       "      <td>江西</td>\n",
       "      <td>76918.16</td>\n",
       "      <td>2.37</td>\n",
       "      <td>2.37</td>\n",
       "      <td>5.965795e+05</td>\n",
       "      <td>1.627851e+05</td>\n",
       "      <td>233585.91</td>\n",
       "      <td>47893.71</td>\n",
       "      <td>...</td>\n",
       "      <td>6.32</td>\n",
       "      <td>2.23</td>\n",
       "      <td>20020716</td>\n",
       "      <td>61470.42</td>\n",
       "      <td>2.59</td>\n",
       "      <td>-12.73</td>\n",
       "      <td>-99.93</td>\n",
       "      <td>13.21</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12763</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2687 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         name industry area        pe  outstanding   totals   totalAssets  \\\n",
       "code                                                                        \n",
       "601288   农业银行       银行   北京      4.95      2940.55  3247.94  1.906410e+09   \n",
       "601166   兴业银行       银行   福建      5.25       190.52   190.52  5.816904e+08   \n",
       "601939   建设银行       银行   北京      5.28        95.94  2500.11  2.050068e+09   \n",
       "601398   工商银行       银行   北京      5.33      2696.12  3564.06  2.364647e+09   \n",
       "601818   光大银行       银行   北京      5.62       398.10   466.79  3.836367e+08   \n",
       "601988   中国银行       银行   北京      5.63      2107.66  2943.88  1.785750e+09   \n",
       "600100   同方股份     电脑设备   北京      6.04        21.98    29.64  5.865951e+06   \n",
       "600015   华夏银行       银行   北京      6.04       106.86   106.86  2.273723e+08   \n",
       "600129   太极集团      中成药   重庆      6.07         4.27     4.27  9.766337e+05   \n",
       "601328   交通银行       银行   上海      6.12       392.51   742.63  8.091810e+08   \n",
       "000001   平安银行       银行   深圳      6.28       146.31   171.70  2.791238e+08   \n",
       "600016   民生银行       银行   北京      6.30       295.52   364.85  5.636577e+08   \n",
       "600000   浦发银行       银行   上海      6.45       205.19   216.18  5.564282e+08   \n",
       "600036   招商银行       银行   深圳      6.52       206.29   252.20  5.563990e+08   \n",
       "000625   长安汽车     汽车整车   重庆      7.07        37.61    48.03  1.006183e+07   \n",
       "601998   中信银行       银行   北京      7.21       319.05   489.35  5.541535e+08   \n",
       "000600   建投能源     火力发电   河北      7.37        10.90    17.92  2.766110e+06   \n",
       "601169   北京银行       银行   北京      7.50       152.07   152.07  2.042843e+08   \n",
       "002142   宁波银行       银行   浙江      7.95        34.52    39.00  8.376893e+07   \n",
       "601009   南京银行       银行   江苏      8.02        57.64    60.59  1.023218e+08   \n",
       "600177    雅戈尔       服饰   浙江      8.05        22.27    25.58  6.449872e+06   \n",
       "601668   中国建筑     建筑施工   北京      8.07       299.47   300.00  1.343098e+08   \n",
       "600029   南方航空       空运   广东      8.17        70.23    98.18  1.925870e+07   \n",
       "600741   华域汽车     汽车配件   上海      8.48        25.83    31.53  1.029029e+07   \n",
       "600104   上汽集团     汽车整车   上海      8.56       110.26   110.26  5.449458e+07   \n",
       "600011   华能国际     火力发电   北京      8.60       105.00   152.00  2.997238e+07   \n",
       "601318   中国平安       保险   深圳      8.60       108.33   182.80  5.296564e+08   \n",
       "600730   中国高科      综合类   北京      8.66         5.87     5.87  4.446449e+05   \n",
       "600718   东软集团     软件服务   辽宁      8.85        12.32    12.43  1.134156e+06   \n",
       "601229   上海银行       银行   上海      9.56         6.00    60.04  1.650924e+08   \n",
       "...       ...      ...  ...       ...          ...      ...           ...   \n",
       "000567   海德股份     区域地产   海南   2692.87         1.50     1.51  2.634341e+04   \n",
       "000017   深中华A     文教休闲   深圳   2762.70         3.03     5.51  6.341910e+03   \n",
       "300122   智飞生物     生物制药   重庆   2908.95         8.63    16.00  2.630953e+05   \n",
       "300469   信息发展     软件服务   上海   3047.43         0.28     0.68  8.266959e+04   \n",
       "603227   雪峰科技     化工原料   新疆   3093.47         4.22     6.59  2.646787e+05   \n",
       "000678   襄阳轴承     机械基件   湖北   3165.57         4.29     4.60  2.598847e+05   \n",
       "600365   通葡股份     红黄药酒   吉林   3268.34         4.00     4.00  9.044611e+04   \n",
       "000885   同力水泥       水泥   河南   3402.66         4.27     4.75  6.076552e+05   \n",
       "600234  *ST山水     文教休闲   山西   3682.71         2.02     2.02  4.892103e+04   \n",
       "600207   安彩高科      元器件   河南   3731.21         6.90     8.63  2.440060e+05   \n",
       "000677   恒天海龙       化纤   山东   3792.81         8.64     8.64  8.437747e+04   \n",
       "000806   银河生物     生物制药   广西   3829.75         6.98    11.00  2.832541e+05   \n",
       "002755   东方新星     建筑施工   北京   3830.17         0.35     1.01  6.840993e+04   \n",
       "600870   厦华电子     家用电器   福建   4031.30         5.23     5.23  3.363180e+03   \n",
       "600435   北方导航     专用机械   北京   4103.53        14.89    14.89  4.290577e+05   \n",
       "002192   融捷股份     专用机械   广东   4225.71         1.90     2.60  9.600925e+04   \n",
       "600836   界龙实业     广告包装   上海   4315.60         6.53     6.63  3.271772e+05   \n",
       "300128   锦富新材      元器件   江苏   4461.88         3.13     4.79  3.613169e+05   \n",
       "600573   惠泉啤酒       啤酒   福建   4539.74         2.50     2.50  1.200594e+05   \n",
       "600685   中船防务       船舶   广东   5027.52         5.49    14.14  5.091487e+06   \n",
       "002468   申通快递     仓储物流   浙江   6677.47         3.32    15.31  1.538426e+05   \n",
       "300093   金刚玻璃       玻璃   广东   7340.19         2.15     2.16  1.277433e+05   \n",
       "002232   启明信息     软件服务   吉林   8756.48         4.02     4.09  1.586020e+05   \n",
       "600316   洪都航空       航空   江西   8969.72         7.17     7.17  1.116128e+06   \n",
       "600728   佳都科技     软件服务   广东   9268.25        13.09    15.54  3.932289e+05   \n",
       "000881   大连国际      综合类   辽宁  10892.01         3.08     3.09  4.570207e+05   \n",
       "603003   龙宇燃油     石油贸易   上海  11344.45         2.02     4.41  5.942213e+05   \n",
       "000691   ST亚太     区域地产   甘肃  17617.77         2.90     3.23  2.812445e+04   \n",
       "000767   漳泽电力     火力发电   山西  20144.57        22.54    22.54  4.053260e+06   \n",
       "600561   江西长运       公路   江西  76918.16         2.37     2.37  5.965795e+05   \n",
       "\n",
       "        liquidAssets  fixedAssets     reserved   ...      bvps      pb  \\\n",
       "code                                             ...                     \n",
       "601288  0.000000e+00  14948499.00   9877300.00   ...      3.79    0.83   \n",
       "601166  0.000000e+00   1142800.00   5086100.00   ...     16.70    0.97   \n",
       "601939  0.000000e+00  16200701.00  13454301.00   ...      6.24    0.88   \n",
       "601398  0.000000e+00  20636500.00  15198099.00   ...      5.21    0.85   \n",
       "601818  0.000000e+00   1380800.00   3336500.00   ...      4.67    0.84   \n",
       "601988  0.000000e+00  18072500.00  14170800.00   ...      4.38    0.79   \n",
       "600100  2.892276e+06    472090.84    926180.38   ...      7.65    1.81   \n",
       "600015  0.000000e+00   1097500.00   2876100.00   ...     12.01    0.92   \n",
       "600129  5.172268e+05    176929.02     21943.88   ...      3.73    4.72   \n",
       "601328  0.000000e+00   9585300.00  11339200.00   ...      7.49    0.77   \n",
       "000001  0.000000e+00    740700.00   5646500.00   ...     10.38    0.88   \n",
       "600016  0.000000e+00   3827100.00   6474400.00   ...      8.95    1.01   \n",
       "600000  0.000000e+00   2097700.00   7467800.00   ...     15.26    1.06   \n",
       "600036  0.000000e+00   3591400.00   6752300.00   ...     15.72    1.14   \n",
       "000625  5.804083e+06   1492460.25    322748.94   ...      8.37    1.81   \n",
       "601998  0.000000e+00   1544000.00   5863600.00   ...      6.99    0.97   \n",
       "000600  3.989108e+05   1423318.25    440487.59   ...      6.37    1.41   \n",
       "601169  0.000000e+00    791700.00   2623600.00   ...      8.12    1.21   \n",
       "002142  0.000000e+00    334290.19    994823.63   ...     11.65    1.48   \n",
       "601009  0.000000e+00    511091.00   1518646.25   ...     10.17    1.10   \n",
       "600177  2.741906e+06    437789.19    488559.69   ...      8.86    1.57   \n",
       "601668  1.069322e+08   2756152.75   1529999.38   ...      6.21    1.43   \n",
       "600029  1.390200e+06  14417901.00   1395100.00   ...      4.52    1.58   \n",
       "600741  6.456056e+06   1394430.38   1251345.88   ...     11.53    1.39   \n",
       "600104  2.930907e+07   4209782.50   4098541.50   ...     16.70    1.43   \n",
       "600011  3.045625e+06  19128846.00   1825077.75   ...      5.45    1.30   \n",
       "601318  0.000000e+00   3628800.00  12264600.00   ...     20.75    1.71   \n",
       "600730  3.642337e+05       355.26      5055.50   ...      3.47    3.61   \n",
       "600718  5.830918e+05    148886.63     69191.85   ...      6.34    3.06   \n",
       "601229  0.000000e+00    390415.59   2039269.75   ...     19.13    1.21   \n",
       "...              ...          ...          ...   ...       ...     ...   \n",
       "000567  1.868432e+04       574.40     11672.82   ...      1.46   26.47   \n",
       "000017  5.631660e+03       381.31     62783.43   ...      0.03  553.51   \n",
       "300122  1.134749e+05     60383.13     20796.47   ...      1.56   10.51   \n",
       "300469  7.082196e+04      1580.30     21445.93   ...      6.12   12.75   \n",
       "603227  1.367015e+05     88838.60     32702.28   ...      1.75    4.74   \n",
       "000678  1.109135e+05     88834.68     71874.57   ...      2.55    6.06   \n",
       "600365  6.185193e+04     13715.70     54790.86   ...      1.71    6.55   \n",
       "000885  1.004939e+05    319444.41    119025.63   ...      4.61    4.45   \n",
       "600234  1.368140e+03       159.75     29344.50   ...      0.24   78.25   \n",
       "600207  1.181447e+05     72502.10    287230.00   ...      2.18    4.22   \n",
       "000677  3.221469e+04     42395.84     69768.81   ...      0.31   22.96   \n",
       "000806  1.715002e+05     37434.06    105668.88   ...      1.84    8.88   \n",
       "002755  6.353088e+04      3499.25     14137.30   ...      5.00    7.94   \n",
       "600870  3.325810e+03         5.36    228420.30   ...      0.04  236.10   \n",
       "600435  2.603250e+05     98119.21      7020.97   ...      1.36   10.30   \n",
       "002192  3.076586e+04     12430.26     51183.68   ...      2.82    7.94   \n",
       "600836  2.108945e+05     58898.56     10020.80   ...      1.32    6.81   \n",
       "300128  1.810279e+05     54136.43    130508.92   ...      4.63    3.74   \n",
       "600573  6.282566e+04     48567.73     50606.55   ...      4.37    3.64   \n",
       "600685  3.641800e+06   1028224.63    686758.50   ...      7.27    4.31   \n",
       "002468  9.928536e+04     41224.78     26216.80   ...      2.20   13.78   \n",
       "300093  7.190043e+04     46292.26     38683.30   ...      4.04    5.93   \n",
       "002232  1.071229e+05     34809.59     26188.17   ...      2.46    5.42   \n",
       "600316  6.728828e+05    149892.22    314009.31   ...      7.18    2.88   \n",
       "600728  3.268362e+05      7726.83    111346.32   ...      1.66    5.14   \n",
       "000881  2.754908e+05    177149.02     25370.17   ...      2.69   10.40   \n",
       "603003  5.463700e+05     13997.30    354252.78   ...      9.23    2.33   \n",
       "000691  2.675598e+04        87.48     14785.37   ...      0.26   41.37   \n",
       "000767  8.162328e+05   2205825.50    228593.95   ...      2.57    1.53   \n",
       "600561  1.627851e+05    233585.91     47893.71   ...      6.32    2.23   \n",
       "\n",
       "        timeToMarket         undp  perundp      rev   profit    gpr    npr  \\\n",
       "code                                                                         \n",
       "601288      20100715  48712500.00     1.50    -5.19     0.63   0.00  39.92   \n",
       "601166      20070205  17284100.00     9.07     5.61     6.70   0.00  37.07   \n",
       "601939      20070925  77305800.00     3.09     3.32     1.19   0.00  41.02   \n",
       "601398      20061027  92104800.00     2.58    -1.31     0.46   0.00  43.03   \n",
       "601818      20100818   7881000.00     1.69     1.01     2.35   0.00  34.54   \n",
       "601988      20060705  55911200.00     1.90     3.45     2.48   0.00  36.53   \n",
       "600100      19970627    912290.63     3.08    -4.44   799.41  17.72  29.74   \n",
       "600015      20030912   5330100.00     4.99    10.25     5.07   0.00  30.71   \n",
       "600129      19971118     64576.25     1.51     5.85   358.80  29.75  16.27   \n",
       "601328      20070515   9299600.00     1.25     0.61     1.03   0.00  35.69   \n",
       "000001      19910403   6946300.00     4.05    15.20     5.52   0.00  22.84   \n",
       "600016      20001219  13243800.00     3.63     0.18     2.05   0.00  33.65   \n",
       "600000      19991110   8579200.00     3.97    11.32     9.47   0.00  33.64   \n",
       "600036      20020409  19801900.00     7.85     2.60     7.51   0.00  32.53   \n",
       "000625      19970610   2865065.25     5.97    11.43    14.81  17.18  14.44   \n",
       "601998      20070427  14283699.00     2.92     7.34     4.91   0.00  29.95   \n",
       "000600      19960606    478985.81     2.67    -5.53    -6.25  41.48  24.21   \n",
       "601169      20070919   4749500.00     3.12    10.07     5.79   0.00  41.20   \n",
       "002142      20070719   1984291.75     5.09    27.01    19.22   0.00  35.36   \n",
       "601009      20070719   1694453.25     2.80    26.84    22.67   0.00  30.16   \n",
       "600177      19981119   1518807.13     5.94   -14.95     1.64  42.38  31.43   \n",
       "601668      20090729  11804222.00     3.93     9.63    30.05   9.46   3.70   \n",
       "600029      20030725   1903500.00     1.94     1.52    37.45  19.54   7.43   \n",
       "600741      19960826   1713783.75     5.44    29.11    12.11  13.75   4.81   \n",
       "600104      19971125   9434767.00     8.56    11.50     8.60  12.42   4.41   \n",
       "600011      20011206   3980688.75     2.62   -14.43   -29.06  26.89  11.28   \n",
       "601318      20070301  18007000.00     9.85    15.41    17.05   0.00  10.35   \n",
       "600730      19960726     97027.65     1.65    94.40   878.09   3.08  54.62   \n",
       "600718      19960618    523895.31     4.21     1.77  1161.01  33.60  41.48   \n",
       "601229      20161116   3215868.50     5.36     0.00     0.00   0.00  41.30   \n",
       "...              ...          ...      ...      ...      ...    ...    ...   \n",
       "000567      19940525     -4852.41    -0.32    64.80   -88.81  50.22   7.84   \n",
       "000017      19920331   -119800.97    -2.17   -13.91   286.64   9.63   1.73   \n",
       "300122      20100928     60421.76     0.38   -50.79   -95.79  92.73   2.47   \n",
       "300469      20150611     12021.07     1.76    34.87   156.65  41.20   0.44   \n",
       "603227      20150515     11085.57     0.17    -0.78   -98.66  24.90   0.22   \n",
       "000678      19970106     -7968.81    -0.17    20.28   105.59   9.78   0.15   \n",
       "600365      20010115    -26907.95    -0.67    32.55   -44.72  20.25   0.27   \n",
       "000885      19990319     40866.26     0.86   -10.47   -97.62  20.99   0.10   \n",
       "600234      20000615    -46093.07    -2.28    34.35   105.33 -66.01   6.86   \n",
       "600207      19990714   -224799.95    -2.60     7.10   -97.26  12.92   0.12   \n",
       "000677      19961226   -150702.95    -1.74   -77.44   100.49  15.32   0.33   \n",
       "000806      19980416    -22164.46    -0.20    38.52   -96.60  25.25   0.42   \n",
       "002755      20150515     23398.80     2.31   -48.84   -95.92  13.42   0.74   \n",
       "600870      19950228   -285958.34    -5.47  1055.98   -86.42   2.73   0.26   \n",
       "600435      20030704     38081.90     0.26     3.71    12.68  29.44   0.41   \n",
       "002192      20071205     -5361.30    -0.21    32.35   109.61  34.27   0.66   \n",
       "600836      19940224     10631.44     0.16    31.98   -74.15  15.36   0.09   \n",
       "300128      20101013     40601.00     0.85   -17.70   -72.44  11.43   0.07   \n",
       "600573      20030226     20337.03     0.81   -20.58   -98.26  33.46   0.13   \n",
       "600685      19931028    111755.51     0.79    -0.43   100.70   6.14   0.04   \n",
       "002468      20100908     10487.73     0.07     2.77     5.38  14.47   0.48   \n",
       "300093      20100708     22002.77     1.02    -8.00   -93.83  35.96   0.22   \n",
       "002232      20080509     28205.65     0.69   -20.80   105.16  19.72   0.08   \n",
       "600316      20001215     66772.96     0.93    26.50   -88.75   6.49   0.06   \n",
       "600728      19960716    -17294.75    -0.11     7.42   107.65  14.49   0.07   \n",
       "000881      19980902     17582.60     0.57    -3.67   100.07  10.86   0.04   \n",
       "603003      20120817      5864.00     0.13    39.36   100.95   0.94   0.01   \n",
       "000691      19970228    -40366.71    -1.25   -52.96   108.00  30.67   0.63   \n",
       "000767      19970609    107255.30     0.48   -33.18   -99.90  15.45   0.01   \n",
       "600561      20020716     61470.42     2.59   -12.73   -99.93  13.21   0.00   \n",
       "\n",
       "        holders  \n",
       "code             \n",
       "601288   482421  \n",
       "601166   218666  \n",
       "601939   440217  \n",
       "601398   573028  \n",
       "601818   275188  \n",
       "601988   884907  \n",
       "600100   233560  \n",
       "600015   121711  \n",
       "600129    53839  \n",
       "601328   408964  \n",
       "000001   340324  \n",
       "600016   316935  \n",
       "600000   162071  \n",
       "600036   215532  \n",
       "000625   143113  \n",
       "601998   205677  \n",
       "000600    53737  \n",
       "601169   157219  \n",
       "002142    86763  \n",
       "601009    85675  \n",
       "600177   140872  \n",
       "601668   775140  \n",
       "600029   295297  \n",
       "600741    63088  \n",
       "600104   103501  \n",
       "600011    97887  \n",
       "601318   274601  \n",
       "600730    71056  \n",
       "600718    86139  \n",
       "601229   551958  \n",
       "...         ...  \n",
       "000567    13380  \n",
       "000017    53355  \n",
       "300122    12761  \n",
       "300469    15310  \n",
       "603227    46228  \n",
       "000678    39676  \n",
       "600365    34615  \n",
       "000885    23748  \n",
       "600234    20994  \n",
       "600207    49192  \n",
       "000677    57272  \n",
       "000806    81900  \n",
       "002755    21214  \n",
       "600870    28634  \n",
       "600435   139413  \n",
       "002192    38248  \n",
       "600836    77781  \n",
       "300128    19633  \n",
       "600573    12777  \n",
       "600685    50359  \n",
       "002468    24617  \n",
       "300093    17041  \n",
       "002232    52591  \n",
       "600316    57176  \n",
       "600728    72583  \n",
       "000881    23153  \n",
       "603003    10977  \n",
       "000691    17725  \n",
       "000767   167387  \n",
       "600561    12763  \n",
       "\n",
       "[2687 rows x 22 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['pe']!=0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>reserved</th>\n",
       "      <th>...</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [name, industry, area, pe, outstanding, totals, totalAssets, liquidAssets, fixedAssets, reserved, reservedPerShare, esp, bvps, pb, timeToMarket, undp, perundp, rev, profit, gpr, npr, holders]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 22 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['industry']=='*国资＊']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data2=data['industry']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data3=data2.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data4=data3.order()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "110"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data4.count()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 去掉重复项，统计某一列的数量 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "name                110\n",
       "industry            110\n",
       "area                110\n",
       "pe                  110\n",
       "outstanding         110\n",
       "totals              110\n",
       "totalAssets         110\n",
       "liquidAssets        110\n",
       "fixedAssets         110\n",
       "reserved            110\n",
       "reservedPerShare    110\n",
       "esp                 110\n",
       "bvps                110\n",
       "pb                  110\n",
       "timeToMarket        110\n",
       "undp                110\n",
       "perundp             110\n",
       "rev                 110\n",
       "profit              110\n",
       "gpr                 110\n",
       "npr                 110\n",
       "holders             110\n",
       "dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.drop_duplicates(subset='industry').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>reserved</th>\n",
       "      <th>...</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>603877</th>\n",
       "      <td>太平鸟</td>\n",
       "      <td>服饰</td>\n",
       "      <td>浙江</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>445669.50</td>\n",
       "      <td>328332.25</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.07</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600680</th>\n",
       "      <td>上海普天</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>上海</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.57</td>\n",
       "      <td>3.82</td>\n",
       "      <td>315171.09</td>\n",
       "      <td>164762.84</td>\n",
       "      <td>10579.21</td>\n",
       "      <td>86835.21</td>\n",
       "      <td>...</td>\n",
       "      <td>3.23</td>\n",
       "      <td>11.23</td>\n",
       "      <td>19931018</td>\n",
       "      <td>-13575.19</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>-47.16</td>\n",
       "      <td>-36.76</td>\n",
       "      <td>20.48</td>\n",
       "      <td>-7.56</td>\n",
       "      <td>55708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601866</th>\n",
       "      <td>中远海发</td>\n",
       "      <td>水运</td>\n",
       "      <td>上海</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79.32</td>\n",
       "      <td>116.83</td>\n",
       "      <td>11134726.00</td>\n",
       "      <td>2688701.75</td>\n",
       "      <td>5626099.00</td>\n",
       "      <td>130668.76</td>\n",
       "      <td>...</td>\n",
       "      <td>1.19</td>\n",
       "      <td>3.47</td>\n",
       "      <td>20071212</td>\n",
       "      <td>197425.27</td>\n",
       "      <td>0.17</td>\n",
       "      <td>-55.62</td>\n",
       "      <td>-148.60</td>\n",
       "      <td>8.62</td>\n",
       "      <td>-5.26</td>\n",
       "      <td>441392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002417</th>\n",
       "      <td>三元达</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>福建</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.10</td>\n",
       "      <td>2.70</td>\n",
       "      <td>77885.56</td>\n",
       "      <td>73511.13</td>\n",
       "      <td>760.84</td>\n",
       "      <td>40803.03</td>\n",
       "      <td>...</td>\n",
       "      <td>1.39</td>\n",
       "      <td>11.84</td>\n",
       "      <td>20100601</td>\n",
       "      <td>-33144.46</td>\n",
       "      <td>-1.23</td>\n",
       "      <td>-25.59</td>\n",
       "      <td>-522.08</td>\n",
       "      <td>21.31</td>\n",
       "      <td>-36.61</td>\n",
       "      <td>19410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601388</th>\n",
       "      <td>怡球资源</td>\n",
       "      <td>铝</td>\n",
       "      <td>江苏</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.25</td>\n",
       "      <td>20.25</td>\n",
       "      <td>419278.88</td>\n",
       "      <td>282600.53</td>\n",
       "      <td>95723.30</td>\n",
       "      <td>8520.78</td>\n",
       "      <td>...</td>\n",
       "      <td>1.05</td>\n",
       "      <td>3.71</td>\n",
       "      <td>20120423</td>\n",
       "      <td>10247.46</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-6.60</td>\n",
       "      <td>-136.45</td>\n",
       "      <td>9.43</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>74513</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        name industry area   pe  outstanding  totals  totalAssets  \\\n",
       "code                                                                \n",
       "603877   太平鸟       服饰   浙江  0.0         0.00    0.00    445669.50   \n",
       "600680  上海普天     通信设备   上海  0.0         2.57    3.82    315171.09   \n",
       "601866  中远海发       水运   上海  0.0        79.32  116.83  11134726.00   \n",
       "002417   三元达     通信设备   福建  0.0         2.10    2.70     77885.56   \n",
       "601388  怡球资源        铝   江苏  0.0        20.25   20.25    419278.88   \n",
       "\n",
       "        liquidAssets  fixedAssets   reserved   ...     bvps     pb  \\\n",
       "code                                           ...                   \n",
       "603877     328332.25         0.00       0.00   ...     0.00   0.00   \n",
       "600680     164762.84     10579.21   86835.21   ...     3.23  11.23   \n",
       "601866    2688701.75   5626099.00  130668.76   ...     1.19   3.47   \n",
       "002417      73511.13       760.84   40803.03   ...     1.39  11.84   \n",
       "601388     282600.53     95723.30    8520.78   ...     1.05   3.71   \n",
       "\n",
       "        timeToMarket       undp  perundp    rev  profit    gpr    npr  holders  \n",
       "code                                                                            \n",
       "603877             0       0.00     0.00   0.00    0.00   0.00   6.07        0  \n",
       "600680      19931018  -13575.19    -0.36 -47.16  -36.76  20.48  -7.56    55708  \n",
       "601866      20071212  197425.27     0.17 -55.62 -148.60   8.62  -5.26   441392  \n",
       "002417      20100601  -33144.46    -1.23 -25.59 -522.08  21.31 -36.61    19410  \n",
       "601388      20120423   10247.46     0.05  -6.60 -136.45   9.43  -0.25    74513  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data['code']=data.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "      code  \n",
       "name  603877       太平鸟\n",
       "      600680      上海普天\n",
       "      601866      中远海发\n",
       "      002417       三元达\n",
       "      601388      怡球资源\n",
       "      600247      ST成城\n",
       "      000892      星美联合\n",
       "      600539      ST狮头\n",
       "      002052      同洲电子\n",
       "      300142      沃森生物\n",
       "      601616      广电电气\n",
       "      000692      惠天热电\n",
       "      600744      华银电力\n",
       "      600686      金龙汽车\n",
       "      000837      秦川机床\n",
       "      600071      凤凰光学\n",
       "      002309      中利科技\n",
       "      600117      西宁特钢\n",
       "      601558      华锐风电\n",
       "      600596      新安股份\n",
       "      600777      新潮能源\n",
       "      300105      龙源技术\n",
       "      300167      迪威视讯\n",
       "      300029      天龙光电\n",
       "      000955      欣龙控股\n",
       "      600476      湘邮科技\n",
       "      600239      云南城投\n",
       "      002181     粤 传 媒\n",
       "      603333      明星电缆\n",
       "      000918       嘉凯城\n",
       "                 ...  \n",
       "code  000567    000567\n",
       "      000017    000017\n",
       "      300122    300122\n",
       "      300469    300469\n",
       "      603227    603227\n",
       "      000678    000678\n",
       "      600365    600365\n",
       "      000885    000885\n",
       "      600234    600234\n",
       "      600207    600207\n",
       "      000677    000677\n",
       "      000806    000806\n",
       "      002755    002755\n",
       "      600870    600870\n",
       "      600435    600435\n",
       "      002192    002192\n",
       "      600836    600836\n",
       "      300128    300128\n",
       "      600573    600573\n",
       "      600685    600685\n",
       "      002468    002468\n",
       "      300093    300093\n",
       "      002232    002232\n",
       "      600316    600316\n",
       "      600728    600728\n",
       "      000881    000881\n",
       "      603003    603003\n",
       "      000691    000691\n",
       "      000767    000767\n",
       "      600561    600561\n",
       "dtype: object"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.unstack()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
